Server Application

This method is used to create a backup using DBUtils while standing at the server computer. You will also need to run an initial backup to save the settings for scheduling a Windows Scheduled Task.

 

Highlight the ap_townname database you wish to backup. Choose the browse button (…) and navigate to the appropriate backup folder and name the file (e.g. ap_townname.bak). You can choose to check the box “Compress Backup to ZIP File” if you would like to compress the backup.

 

 

Press the Backup button to create the backup file. This method creates a single backup file and must be initiated manually.

 

Scheduling Automated Backups on the Server

This method is used to schedule backups for one or more databases using DBUtils and DBUtilsScheduled. Again, this is performed on the server. You will first need to run an initial manual backup using DBUtils as outlined above to save the settings for a scheduled backup for each database. When doing so, make sure to check the box to Include Database in Scheduled Backups and once you press Backup make certain to indicate you wish to save the settings for use with the scheduled backups.

 

Once you have configured the settings for each database you wish to include in the scheduled backup, you will need to add DBUtilsScheduled.exe (located in the C:\Program Files\Civicware folder as a Windows Scheduled Task. DBUtilsScheduled uses the settings configured within DBUtils to create backups without the need for user input.

For information on creating a Windows Scheduled Task refer to http://support.microsoft.com/kb/308569